package stock.data;

/**
 * RDB meta data info
 * @author i062843
 *
 */
public interface DatabaseMetadata {

	static String DATABASE_NAME = "trading";
	
	static String TRUNCATE_TABLE = "truncate %s";
	
	//SECURITY_INFO_TABLE
	static String SECURITY_INFO_TABLE = "security_info";
	static String SECURITY_INFO_ID = "id";
	static String SECURITY_INFO_NAME = "name";
	static String INSERT_SECURITY_INFO = "insert into security_info (id, name) values(?, ?)";
	
	//SECURITY_DATA_TABLE
	static String SECURITY_DATA_TABLE = "security_data";
	static String SECURITY_DATA_SECURITY_ID = "security_id";
	static String SECURITY_DATA_OPEN = "open";
	static String SECURITY_DATA_HIGH = "high";
	static String SECURITY_DATA_LOW = "low";
	static String SECURITY_DATA_CLOSE = "close";
	static String SECURITY_DATA_VOLUME = "volume";
	static String SEUCIRYT_DATA_AMOUNT = "amount";	
	
	static String INSERT_SECURITY_DATA = "insert into security_data (security_id, date, open, high, low, close, volume, amount) values(?, ?, ?, ?,?, ?, ?, ?)";
	
}
